/**
 *  iBizSys 5.0 机器人生产代码（不要直接修改当前代码）
 *  http://www.ibizsys.net
 */
package com.sa.ibiz.demo.srv.demo.demodel;



import net.ibizsys.paas.core.DEDataQuery;
import net.ibizsys.paas.core.DEDataQueryCodes;
import net.ibizsys.paas.core.DEDataQueryCode;
import net.ibizsys.paas.core.DEDataQueryCodeExp;
import net.ibizsys.paas.core.DEDataQueryCodeCond;

@DEDataQuery(id="8F82B535-D9D2-429F-A572-7E34641BC9FF",name="DEFAULT")
@DEDataQueryCodes({
    @DEDataQueryCode(querycode="SELECT t1.`QUANTITY`*t11.`UNITPRICE` AS `AMOUNT`, t1.`CREATEDATE`, t1.`CREATEMAN`, t1.`IBZ5ORDERDETAILID`, t1.`IBZ5ORDERDETAILNAME`, t1.`IBZ5ORDERID`, t21.`IBZ5ORDERNAME`, t1.`IBZ5UNITPRODUCTID`, t11.`IBZ5UNITPRODUCTNAME`, t21.`ORDERUID`, t1.`QUANTITY`, t11.`UNIT`, t11.`UNITPRICE`, t1.`UPDATEDATE`, t1.`UPDATEMAN` FROM `T_IBZ5ORDERDETAIL` t1  LEFT JOIN T_IBZ5UNITPRODUCT t11 ON t1.IBZ5UNITPRODUCTID = t11.IBZ5UNITPRODUCTID  LEFT JOIN T_IBZ5ORDER t21 ON t1.IBZ5ORDERID = t21.IBZ5ORDERID  ",querycodetemp="",declarecode="",dbtype="MYSQL5",
    fieldexps={
        @DEDataQueryCodeExp(name="AMOUNT",expression="t1.`QUANTITY`*t11.`UNITPRICE`")
        ,@DEDataQueryCodeExp(name="CREATEDATE",expression="t1.`CREATEDATE`")
        ,@DEDataQueryCodeExp(name="CREATEMAN",expression="t1.`CREATEMAN`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERDETAILID",expression="t1.`IBZ5ORDERDETAILID`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERDETAILNAME",expression="t1.`IBZ5ORDERDETAILNAME`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERID",expression="t1.`IBZ5ORDERID`")
        ,@DEDataQueryCodeExp(name="IBZ5ORDERNAME",expression="t21.`IBZ5ORDERNAME`")
        ,@DEDataQueryCodeExp(name="IBZ5UNITPRODUCTID",expression="t1.`IBZ5UNITPRODUCTID`")
        ,@DEDataQueryCodeExp(name="IBZ5UNITPRODUCTNAME",expression="t11.`IBZ5UNITPRODUCTNAME`")
        ,@DEDataQueryCodeExp(name="ORDERUID",expression="t21.`ORDERUID`")
        ,@DEDataQueryCodeExp(name="QUANTITY",expression="t1.`QUANTITY`")
        ,@DEDataQueryCodeExp(name="UNIT",expression="t11.`UNIT`")
        ,@DEDataQueryCodeExp(name="UNITPRICE",expression="t11.`UNITPRICE`")
        ,@DEDataQueryCodeExp(name="UPDATEDATE",expression="t1.`UPDATEDATE`")
        ,@DEDataQueryCodeExp(name="UPDATEMAN",expression="t1.`UPDATEMAN`")
    },
    conds={})
})
/**
 *  实体数据查询 [DEFAULT]模型基类
 */
public class IBZ5ORDERDETAILDefaultDQModel extends net.ibizsys.paas.demodel.DEDataQueryModelBase {

    public IBZ5ORDERDETAILDefaultDQModel() {
        super();

        this.initAnnotation(IBZ5ORDERDETAILDefaultDQModel.class);
    }

}